File Data Sources
To connect to a file data source, add the required node to the canvas. From the Properties panel, select the way you want to connect to the file: upload the file, connect to a shared file, or connect to a URL.
Step 1. Select a File Type
Add the required node to the canvas:
- Supports local file upload, or pointer to a shared file on a network drive
- Each sheet within the given Access file is converted into a table
- Each column within the sheet is converted into a column within the corresponding table
- Supports local file upload, or pointer to a shared file on a network drive, or URL address
- Each sheet within the given Excel file is converted into a table
- Each column within the sheet is converted into a column within the corresponding table
- Supports local file upload, or pointer to a shared file on a network drive, or URL address
- Each JSON file is converted into a single table
- Supports pointer to a shared file on a network drive
- Enter the extension(s) of the files to upload
- Each extension must be preceded by an asterisk, and multiple extensions must be delimited by a coma and then a space. For example: *.txt, *.csv
- Each file must have the same structure (columns) and file type (i.e. Text, JSON, or XML)
-
Note: this data source is not available in the Community Edition.
- Supports local file upload, or pointer to a shared .sas7bdat file on a network drive, or URL address
- Supports local file upload, or pointer to a shared file on a network drive
- Supports both Fixed Width Column files, and Delimited files
- Click here for details about Text file sources
- Supports local file upload, or pointer to a shared file on a network drive, or URL address
- Each XML file is converted into a single table
Step 2. Select a Connection Type
Uploaded File
To upload a file, either drag and drop the file from its folder location onto the Properties panel, or click the blue Upload File button, and then find and select the file from its folder location.
Shared File
To connect to a shared file, enter the shared file path in the Properties panel. The shared file must use a UNC file path format to the shared directory and file on the network. The machine hosting Pyramid must have access to the shared file location. If the Pyramid services are running on different machines, the Runtime and Task Servers must be given access to the shared file location.
URL
The data will be downloaded from the URL when the model is processed. To connect to a URL, enter the URL and its required authorization:
- None: select None if no authorization is required
- Basic Authentication: if basic authentication is required
- Custom Header: if custom header authorization is required
Step 3. Table Selection
From the Table Selection panel select the tables that should be added to the Data Flow.